Cells("PinY") not working correctly when number is a negative value

Hi There

I have written a Viso macro that pastes items from one page to another and orders them on the page. To move the item I am using the command myItem.Cells("PinY").FormulaU = dY

After an item is pasted dY is decreased by 3 (i.e. dY = dY -3)

This works fine until the value of Y becomes negative. When it gets to -3 for some reason it moves it to -14.1929

I have stepped through the code and have checked that the value of dY is correct.

Any ideas?

Regards

Alasdair

 


  • Edited by A Patton Tuesday, August 19, 2014 4:22 PM
August 19th, 2014 7:21pm

Hi Alasdair

This is a forum which support technical issue in Visio client, if you want to receive more information about developing, I suggest you posting this issue in MSDN forum.

http://social.msdn.microsoft.com/Forums/office/en-US/home?category=officedev

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

Thanks for your understanding.

Best regards,

Greta Ge
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
August 25th, 2014 4:07am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics